Overview
Brought to you by YData
Dataset statistics
| Number of variables | 16 |
|---|---|
| Number of observations | 700 |
| Missing cells | 53 |
| Missing cells (%) | 0.5% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 87.6 KiB |
| Average record size in memory | 128.2 B |
Variable types
| Categorical | 6 |
|---|---|
| Numeric | 9 |
| DateTime | 1 |
Sales is highly overall correlated with COGS and 4 other fields | High correlation |
COGS is highly overall correlated with Sales and 3 other fields | High correlation |
Discounts is highly overall correlated with Sales and 3 other fields | High correlation |
Gross Sales is highly overall correlated with Sales and 4 other fields | High correlation |
Manufacturing Price is highly overall correlated with Product | High correlation |
Month Name is highly overall correlated with Month Number and 1 other fields | High correlation |
Month Number is highly overall correlated with Month Name and 1 other fields | High correlation |
Product is highly overall correlated with Manufacturing Price | High correlation |
Profit is highly overall correlated with Sales and 2 other fields | High correlation |
Sale Price is highly overall correlated with Sales and 5 other fields | High correlation |
Segment is highly overall correlated with Sale Price | High correlation |
Year is highly overall correlated with Month Name and 1 other fields | High correlation |
Discount Band has 53 (7.6%) missing values | Missing |
Country is uniformly distributed | Uniform |
Discounts has 53 (7.6%) zeros | Zeros |
Reproduction
| Analysis started | 2024-11-19 13:05:21.825621 |
|---|---|
| Analysis finished | 2024-11-19 13:05:45.313398 |
| Duration | 23.49 seconds |
| Software version | ydata-profiling vv4.12.0 |
| Download configuration | config.json |
Variables
Segment
Categorical
High correlation 
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.6 KiB |
| Government | |
|---|---|
| Midmarket | |
| Channel Partners | |
| Enterprise | |
| Small Business |
Length
| Max length | 16 |
|---|---|
| Median length | 10 |
| Mean length | 11.285714 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Government |
|---|---|
| 2nd row | Government |
| 3rd row | Midmarket |
| 4th row | Midmarket |
| 5th row | Midmarket |
Common Values
| Value | Count | Frequency (%) |
| Government | 300 | |
| Midmarket | 100 | 14.3% |
| Channel Partners | 100 | 14.3% |
| Enterprise | 100 | 14.3% |
| Small Business | 100 | 14.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| government | 300 | |
| midmarket | 100 | 11.1% |
| channel | 100 | 11.1% |
| partners | 100 | 11.1% |
| enterprise | 100 | 11.1% |
| small | 100 | 11.1% |
| business | 100 | 11.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 1200 | |
| n | 1100 | |
| r | 800 | |
| t | 600 | 7.6% |
| m | 500 | 6.3% |
| s | 500 | 6.3% |
| a | 400 | 5.1% |
| G | 300 | 3.8% |
| o | 300 | 3.8% |
| v | 300 | 3.8% |
| Other values (14) | 1900 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7900 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 1200 | |
| n | 1100 | |
| r | 800 | |
| t | 600 | 7.6% |
| m | 500 | 6.3% |
| s | 500 | 6.3% |
| a | 400 | 5.1% |
| G | 300 | 3.8% |
| o | 300 | 3.8% |
| v | 300 | 3.8% |
| Other values (14) | 1900 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7900 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 1200 | |
| n | 1100 | |
| r | 800 | |
| t | 600 | 7.6% |
| m | 500 | 6.3% |
| s | 500 | 6.3% |
| a | 400 | 5.1% |
| G | 300 | 3.8% |
| o | 300 | 3.8% |
| v | 300 | 3.8% |
| Other values (14) | 1900 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7900 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 1200 | |
| n | 1100 | |
| r | 800 | |
| t | 600 | 7.6% |
| m | 500 | 6.3% |
| s | 500 | 6.3% |
| a | 400 | 5.1% |
| G | 300 | 3.8% |
| o | 300 | 3.8% |
| v | 300 | 3.8% |
| Other values (14) | 1900 |
Country
Categorical
Uniform 
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.6 KiB |
| Canada | |
|---|---|
| Germany | |
| France | |
| Mexico | |
| United States of America |
Length
| Max length | 24 |
|---|---|
| Median length | 6 |
| Mean length | 9.8 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Canada |
|---|---|
| 2nd row | Germany |
| 3rd row | France |
| 4th row | Germany |
| 5th row | Mexico |
Common Values
| Value | Count | Frequency (%) |
| Canada | 140 | |
| Germany | 140 | |
| France | 140 | |
| Mexico | 140 | |
| United States of America | 140 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| canada | 140 | |
| germany | 140 | |
| france | 140 | |
| mexico | 140 | |
| united | 140 | |
| states | 140 | |
| of | 140 | |
| america | 140 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 980 | |
| e | 840 | |
| n | 560 | 8.2% |
| t | 420 | 6.1% |
| r | 420 | 6.1% |
| c | 420 | 6.1% |
| 420 | 6.1% | |
| i | 420 | 6.1% |
| d | 280 | 4.1% |
| m | 280 | 4.1% |
| Other values (12) | 1820 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6860 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 980 | |
| e | 840 | |
| n | 560 | 8.2% |
| t | 420 | 6.1% |
| r | 420 | 6.1% |
| c | 420 | 6.1% |
| 420 | 6.1% | |
| i | 420 | 6.1% |
| d | 280 | 4.1% |
| m | 280 | 4.1% |
| Other values (12) | 1820 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6860 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 980 | |
| e | 840 | |
| n | 560 | 8.2% |
| t | 420 | 6.1% |
| r | 420 | 6.1% |
| c | 420 | 6.1% |
| 420 | 6.1% | |
| i | 420 | 6.1% |
| d | 280 | 4.1% |
| m | 280 | 4.1% |
| Other values (12) | 1820 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6860 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 980 | |
| e | 840 | |
| n | 560 | 8.2% |
| t | 420 | 6.1% |
| r | 420 | 6.1% |
| c | 420 | 6.1% |
| 420 | 6.1% | |
| i | 420 | 6.1% |
| d | 280 | 4.1% |
| m | 280 | 4.1% |
| Other values (12) | 1820 |
Product
Categorical
High correlation 
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.6 KiB |
| Paseo | |
|---|---|
| Velo | |
| VTT | |
| Amarilla | |
| Carretera |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 5.7328571 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Carretera |
|---|---|
| 2nd row | Carretera |
| 3rd row | Carretera |
| 4th row | Carretera |
| 5th row | Carretera |
Common Values
| Value | Count | Frequency (%) |
| Paseo | 202 | |
| Velo | 109 | |
| VTT | 109 | |
| Amarilla | 94 | |
| Carretera | 93 | |
| Montana | 93 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| paseo | 202 | |
| velo | 109 | |
| vtt | 109 | |
| amarilla | 94 | |
| carretera | 93 | |
| montana | 93 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 762 | |
| e | 497 | |
| o | 404 | |
| r | 373 | |
| l | 297 | 7.4% |
| V | 218 | 5.4% |
| T | 218 | 5.4% |
| P | 202 | 5.0% |
| s | 202 | 5.0% |
| t | 186 | 4.6% |
| Other values (6) | 654 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4013 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 762 | |
| e | 497 | |
| o | 404 | |
| r | 373 | |
| l | 297 | 7.4% |
| V | 218 | 5.4% |
| T | 218 | 5.4% |
| P | 202 | 5.0% |
| s | 202 | 5.0% |
| t | 186 | 4.6% |
| Other values (6) | 654 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4013 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 762 | |
| e | 497 | |
| o | 404 | |
| r | 373 | |
| l | 297 | 7.4% |
| V | 218 | 5.4% |
| T | 218 | 5.4% |
| P | 202 | 5.0% |
| s | 202 | 5.0% |
| t | 186 | 4.6% |
| Other values (6) | 654 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4013 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 762 | |
| e | 497 | |
| o | 404 | |
| r | 373 | |
| l | 297 | 7.4% |
| V | 218 | 5.4% |
| T | 218 | 5.4% |
| P | 202 | 5.0% |
| s | 202 | 5.0% |
| t | 186 | 4.6% |
| Other values (6) | 654 |
Discount Band
Categorical
Missing 
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 53 |
| Missing (%) | 7.6% |
| Memory size | 5.6 KiB |
| High | |
|---|---|
| Medium | |
| Low |
Length
| Max length | 6 |
|---|---|
| Median length | 4 |
| Mean length | 4.5007728 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Low |
|---|---|
| 2nd row | Low |
| 3rd row | Low |
| 4th row | Low |
| 5th row | Low |
Common Values
| Value | Count | Frequency (%) |
| High | 245 | |
| Medium | 242 | |
| Low | 160 | |
| (Missing) | 53 | 7.6% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| high | 245 | |
| medium | 242 | |
| low | 160 |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 487 | |
| H | 245 | |
| g | 245 | |
| h | 245 | |
| M | 242 | |
| e | 242 | |
| d | 242 | |
| u | 242 | |
| m | 242 | |
| L | 160 | 5.5% |
| Other values (2) | 320 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2912 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 487 | |
| H | 245 | |
| g | 245 | |
| h | 245 | |
| M | 242 | |
| e | 242 | |
| d | 242 | |
| u | 242 | |
| m | 242 | |
| L | 160 | 5.5% |
| Other values (2) | 320 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2912 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 487 | |
| H | 245 | |
| g | 245 | |
| h | 245 | |
| M | 242 | |
| e | 242 | |
| d | 242 | |
| u | 242 | |
| m | 242 | |
| L | 160 | 5.5% |
| Other values (2) | 320 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2912 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 487 | |
| H | 245 | |
| g | 245 | |
| h | 245 | |
| M | 242 | |
| e | 242 | |
| d | 242 | |
| u | 242 | |
| m | 242 | |
| L | 160 | 5.5% |
| Other values (2) | 320 |
Units Sold
Real number (ℝ)
| Distinct | 510 |
|---|---|
| Distinct (%) | 72.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1608.2943 |
| Minimum | 200 |
|---|---|
| Maximum | 4492.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.6 KiB |
Quantile statistics
| Minimum | 200 |
|---|---|
| 5-th percentile | 344.95 |
| Q1 | 905 |
| median | 1542.5 |
| Q3 | 2229.125 |
| 95-th percentile | 2935.95 |
| Maximum | 4492.5 |
| Range | 4292.5 |
| Interquartile range (IQR) | 1324.125 |
Descriptive statistics
| Standard deviation | 867.42786 |
|---|---|
| Coefficient of variation (CV) | 0.53934648 |
| Kurtosis | -0.315318 |
| Mean | 1608.2943 |
| Median Absolute Deviation (MAD) | 655.5 |
| Skewness | 0.43615356 |
| Sum | 1125806 |
| Variance | 752431.09 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 727 | 5 | 0.7% |
| 2844 | 4 | 0.6% |
| 1916 | 4 | 0.6% |
| 663 | 4 | 0.6% |
| 1743 | 4 | 0.6% |
| 1496 | 4 | 0.6% |
| 1372 | 3 | 0.4% |
| 1366 | 3 | 0.4% |
| 293 | 3 | 0.4% |
| 1123 | 3 | 0.4% |
| Other values (500) | 663 |
| Value | Count | Frequency (%) |
| 200 | 1 | |
| 214 | 2 | |
| 218 | 1 | |
| 241 | 2 | |
| 245 | 1 | |
| 257 | 1 | |
| 259 | 1 | |
| 260 | 1 | |
| 263 | 2 | |
| 266 | 1 |
| Value | Count | Frequency (%) |
| 4492.5 | 1 | |
| 4251 | 1 | |
| 4243.5 | 1 | |
| 4219.5 | 1 | |
| 4026 | 1 | |
| 3997.5 | 1 | |
| 3945 | 1 | |
| 3874.5 | 1 | |
| 3864 | 1 | |
| 3850.5 | 1 |
Manufacturing Price
Real number (ℝ)
High correlation 
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 96.477143 |
| Minimum | 3 |
|---|---|
| Maximum | 260 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.6 KiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 5 |
| median | 10 |
| Q3 | 250 |
| 95-th percentile | 260 |
| Maximum | 260 |
| Range | 257 |
| Interquartile range (IQR) | 245 |
Descriptive statistics
| Standard deviation | 108.60261 |
|---|---|
| Coefficient of variation (CV) | 1.1256823 |
| Kurtosis | -1.4289627 |
| Mean | 96.477143 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 0.59258395 |
| Sum | 67534 |
| Variance | 11794.527 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10 | 202 | |
| 120 | 109 | |
| 250 | 109 | |
| 260 | 94 | |
| 3 | 93 | |
| 5 | 93 |
| Value | Count | Frequency (%) |
| 3 | 93 | |
| 5 | 93 | |
| 10 | 202 | |
| 120 | 109 | |
| 250 | 109 | |
| 260 | 94 |
| Value | Count | Frequency (%) |
| 260 | 94 | |
| 250 | 109 | |
| 120 | 109 | |
| 10 | 202 | |
| 5 | 93 | |
| 3 | 93 |
Sale Price
Real number (ℝ)
High correlation 
| Distinct | 7 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 118.42857 |
| Minimum | 7 |
|---|---|
| Maximum | 350 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.6 KiB |
Quantile statistics
| Minimum | 7 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 12 |
| median | 20 |
| Q3 | 300 |
| 95-th percentile | 350 |
| Maximum | 350 |
| Range | 343 |
| Interquartile range (IQR) | 288 |
Descriptive statistics
| Standard deviation | 136.77551 |
|---|---|
| Coefficient of variation (CV) | 1.1549199 |
| Kurtosis | -1.176789 |
| Mean | 118.42857 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 0.77128187 |
| Sum | 82900 |
| Variance | 18707.541 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 20 | 100 | |
| 15 | 100 | |
| 350 | 100 | |
| 12 | 100 | |
| 125 | 100 | |
| 300 | 100 | |
| 7 | 100 |
| Value | Count | Frequency (%) |
| 7 | 100 | |
| 12 | 100 | |
| 15 | 100 | |
| 20 | 100 | |
| 125 | 100 | |
| 300 | 100 | |
| 350 | 100 |
| Value | Count | Frequency (%) |
| 350 | 100 | |
| 300 | 100 | |
| 125 | 100 | |
| 20 | 100 | |
| 15 | 100 | |
| 12 | 100 | |
| 7 | 100 |
Gross Sales
Real number (ℝ)
High correlation 
| Distinct | 550 |
|---|---|
| Distinct (%) | 78.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 182759.43 |
| Minimum | 1799 |
|---|---|
| Maximum | 1207500 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.6 KiB |
Quantile statistics
| Minimum | 1799 |
|---|---|
| 5-th percentile | 5193.05 |
| Q1 | 17391.75 |
| median | 37980 |
| Q3 | 279025 |
| 95-th percentile | 754250 |
| Maximum | 1207500 |
| Range | 1205701 |
| Interquartile range (IQR) | 261633.25 |
Descriptive statistics
| Standard deviation | 254262.28 |
|---|---|
| Coefficient of variation (CV) | 1.3912403 |
| Kurtosis | 2.0543006 |
| Mean | 182759.43 |
| Median Absolute Deviation (MAD) | 30747.5 |
| Skewness | 1.6739217 |
| Sum | 1.279316 × 108 |
| Variance | 6.4649309 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 37050 | 3 | 0.4% |
| 738000 | 3 | 0.4% |
| 22710 | 3 | 0.4% |
| 4404 | 3 | 0.4% |
| 82875 | 3 | 0.4% |
| 26145 | 3 | 0.4% |
| 349625 | 2 | 0.3% |
| 24980 | 2 | 0.3% |
| 921200 | 2 | 0.3% |
| 196250 | 2 | 0.3% |
| Other values (540) | 674 |
| Value | Count | Frequency (%) |
| 1799 | 1 | |
| 1841 | 2 | |
| 1960 | 2 | |
| 2051 | 1 | |
| 2520 | 2 | |
| 2534 | 1 | |
| 2660 | 1 | |
| 2716 | 1 | |
| 3270 | 1 | |
| 3416 | 1 |
| Value | Count | Frequency (%) |
| 1207500 | 1 | |
| 1140750 | 1 | |
| 1138050 | 1 | |
| 1048500 | 1 | |
| 1038100 | 2 | |
| 1006950 | 2 | |
| 1006600 | 1 | |
| 998200 | 2 | |
| 997850 | 1 | |
| 982450 | 1 |
Discounts
Real number (ℝ)
High correlation  Zeros 
| Distinct | 515 |
|---|---|
| Distinct (%) | 73.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13150.355 |
| Minimum | 0 |
|---|---|
| Maximum | 149677.5 |
| Zeros | 53 |
| Zeros (%) | 7.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 800.32 |
| median | 2585.25 |
| Q3 | 15956.344 |
| 95-th percentile | 62832 |
| Maximum | 149677.5 |
| Range | 149677.5 |
| Interquartile range (IQR) | 15156.024 |
Descriptive statistics
| Standard deviation | 22962.929 |
|---|---|
| Coefficient of variation (CV) | 1.7461832 |
| Kurtosis | 7.9057124 |
| Mean | 13150.355 |
| Median Absolute Deviation (MAD) | 2328.57 |
| Skewness | 2.6850389 |
| Sum | 9205248.2 |
| Variance | 5.272961 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 53 | 7.6% |
| 1218.6 | 3 | 0.4% |
| 5690 | 3 | 0.4% |
| 20139 | 3 | 0.4% |
| 4400 | 2 | 0.3% |
| 870.45 | 2 | 0.3% |
| 5005.65 | 2 | 0.3% |
| 3674.4 | 2 | 0.3% |
| 14906.25 | 2 | 0.3% |
| 21490 | 2 | 0.3% |
| Other values (505) | 626 |
| Value | Count | Frequency (%) |
| 0 | 53 | |
| 18.41 | 1 | 0.1% |
| 25.34 | 1 | 0.1% |
| 44.73 | 1 | 0.1% |
| 48.15 | 1 | 0.1% |
| 72.1 | 1 | 0.1% |
| 91.92 | 2 | 0.3% |
| 92.82 | 1 | 0.1% |
| 110.46 | 1 | 0.1% |
| 112.05 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 149677.5 | 1 | |
| 125820 | 1 | |
| 119756 | 2 | |
| 115830 | 1 | |
| 112927.5 | 1 | |
| 111375 | 1 | |
| 109147.5 | 1 | |
| 106722 | 1 | |
| 106512 | 1 | |
| 105367.5 | 1 |
Sales
Real number (ℝ)
High correlation 
| Distinct | 559 |
|---|---|
| Distinct (%) | 79.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 169609.07 |
| Minimum | 1655.08 |
|---|---|
| Maximum | 1159200 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.6 KiB |
Quantile statistics
| Minimum | 1655.08 |
|---|---|
| 5-th percentile | 4535.65 |
| Q1 | 15928 |
| median | 35540.2 |
| Q3 | 261077.5 |
| 95-th percentile | 683574.75 |
| Maximum | 1159200 |
| Range | 1157544.9 |
| Interquartile range (IQR) | 245149.5 |
Descriptive statistics
| Standard deviation | 236726.35 |
|---|---|
| Coefficient of variation (CV) | 1.3957175 |
| Kurtosis | 2.1886331 |
| Mean | 169609.07 |
| Median Absolute Deviation (MAD) | 28716.7 |
| Skewness | 1.6962952 |
| Sum | 1.1872635 × 108 |
| Variance | 5.6039363 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 20794.8 | 2 | 0.3% |
| 334302.5 | 2 | 0.3% |
| 136560 | 2 | 0.3% |
| 26945.6 | 2 | 0.3% |
| 9662.4 | 2 | 0.3% |
| 21801.6 | 2 | 0.3% |
| 303688 | 2 | 0.3% |
| 731472 | 2 | 0.3% |
| 21700.8 | 2 | 0.3% |
| 7707.35 | 2 | 0.3% |
| Other values (549) | 680 |
| Value | Count | Frequency (%) |
| 1655.08 | 1 | |
| 1685.6 | 2 | |
| 1730.54 | 1 | |
| 1763.86 | 1 | |
| 1822.59 | 1 | |
| 2293.2 | 2 | |
| 2335.76 | 1 | |
| 2367.4 | 1 | |
| 2508.66 | 1 | |
| 3139.2 | 1 |
| Value | Count | Frequency (%) |
| 1159200 | 1 | |
| 1038082.5 | 1 | |
| 1035625.5 | 1 | |
| 1017338 | 2 | |
| 986811 | 2 | |
| 978236 | 2 | |
| 962500 | 1 | |
| 936138 | 1 | |
| 922680 | 1 | |
| 884205 | 1 |
COGS
Real number (ℝ)
High correlation 
| Distinct | 545 |
|---|---|
| Distinct (%) | 77.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 145475.21 |
| Minimum | 918 |
|---|---|
| Maximum | 950625 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.6 KiB |
Quantile statistics
| Minimum | 918 |
|---|---|
| 5-th percentile | 2449.5 |
| Q1 | 7490 |
| median | 22506.25 |
| Q3 | 245607.5 |
| 95-th percentile | 608643.75 |
| Maximum | 950625 |
| Range | 949707 |
| Interquartile range (IQR) | 238117.5 |
Descriptive statistics
| Standard deviation | 203865.51 |
|---|---|
| Coefficient of variation (CV) | 1.4013762 |
| Kurtosis | 1.608463 |
| Mean | 145475.21 |
| Median Absolute Deviation (MAD) | 19576.25 |
| Skewness | 1.5490476 |
| Sum | 1.0183265 × 108 |
| Variance | 4.1561145 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 17430 | 4 | 0.6% |
| 8655 | 3 | 0.4% |
| 24700 | 3 | 0.4% |
| 1101 | 3 | 0.4% |
| 15140 | 3 | 0.4% |
| 615000 | 3 | 0.4% |
| 79560 | 3 | 0.4% |
| 335640 | 2 | 0.3% |
| 12490 | 2 | 0.3% |
| 204720 | 2 | 0.3% |
| Other values (535) | 672 |
| Value | Count | Frequency (%) |
| 918 | 1 | 0.1% |
| 1101 | 3 | |
| 1158 | 2 | |
| 1230 | 2 | |
| 1285 | 1 | 0.1% |
| 1315 | 2 | |
| 1400 | 2 | |
| 1416 | 2 | |
| 1465 | 1 | 0.1% |
| 1500 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 950625 | 1 | |
| 948375 | 1 | |
| 897000 | 1 | |
| 873750 | 1 | |
| 771160 | 2 | |
| 748250 | 1 | |
| 748020 | 2 | |
| 747760 | 1 | |
| 741520 | 2 | |
| 741260 | 1 |
Profit
Real number (ℝ)
High correlation 
| Distinct | 557 |
|---|---|
| Distinct (%) | 79.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24133.86 |
| Minimum | -40617.5 |
|---|---|
| Maximum | 262200 |
| Zeros | 5 |
| Zeros (%) | 0.7% |
| Negative | 58 |
| Negative (%) | 8.3% |
| Memory size | 5.6 KiB |
Quantile statistics
| Minimum | -40617.5 |
|---|---|
| 5-th percentile | -7849.25 |
| Q1 | 2805.96 |
| median | 9242.2 |
| Q3 | 22662 |
| 95-th percentile | 117138.1 |
| Maximum | 262200 |
| Range | 302817.5 |
| Interquartile range (IQR) | 19856.04 |
Descriptive statistics
| Standard deviation | 42760.627 |
|---|---|
| Coefficient of variation (CV) | 1.7718105 |
| Kurtosis | 8.6786162 |
| Mean | 24133.86 |
| Median Absolute Deviation (MAD) | 7383.075 |
| Skewness | 2.7121513 |
| Sum | 16893702 |
| Variance | 1.8284712 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 5 | 0.7% |
| 10768.8 | 2 | 0.3% |
| 6822.5 | 2 | 0.3% |
| 7829.35 | 2 | 0.3% |
| 11635.6 | 2 | 0.3% |
| 2952.4 | 2 | 0.3% |
| 6661.6 | 2 | 0.3% |
| 165452 | 2 | 0.3% |
| 47328 | 2 | 0.3% |
| -17481.25 | 2 | 0.3% |
| Other values (547) | 677 |
| Value | Count | Frequency (%) |
| -40617.5 | 1 | |
| -38046.25 | 1 | |
| -35550 | 1 | |
| -35262.5 | 1 | |
| -33522.5 | 1 | |
| -27693.75 | 1 | |
| -25841.25 | 1 | |
| -24160 | 1 | |
| -23870 | 1 | |
| -21560 | 2 |
| Value | Count | Frequency (%) |
| 262200 | 1 | |
| 247500 | 1 | |
| 246178 | 2 | |
| 238791 | 2 | |
| 236716 | 2 | |
| 188378 | 1 | |
| 186407.5 | 2 | |
| 165452 | 2 | |
| 161020 | 1 | |
| 155250 | 1 |
Date
Date
| Distinct | 16 |
|---|---|
| Distinct (%) | 2.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.6 KiB |
| Minimum | 2013-09-01 00:00:00 |
|---|---|
| Maximum | 2014-12-01 00:00:00 |
Month Number
Real number (ℝ)
High correlation 
| Distinct | 12 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.9 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1.95 |
| Q1 | 5.75 |
| median | 9 |
| Q3 | 10.25 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 4.5 |
Descriptive statistics
| Standard deviation | 3.3773206 |
|---|---|
| Coefficient of variation (CV) | 0.42750894 |
| Kurtosis | -0.87915982 |
| Mean | 7.9 |
| Median Absolute Deviation (MAD) | 2.5 |
| Skewness | -0.57829215 |
| Sum | 5530 |
| Variance | 11.406295 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10 | 140 | |
| 12 | 105 | |
| 6 | 70 | |
| 9 | 70 | |
| 11 | 70 | |
| 1 | 35 | 5.0% |
| 3 | 35 | 5.0% |
| 7 | 35 | 5.0% |
| 8 | 35 | 5.0% |
| 2 | 35 | 5.0% |
| Other values (2) | 70 |
| Value | Count | Frequency (%) |
| 1 | 35 | 5.0% |
| 2 | 35 | 5.0% |
| 3 | 35 | 5.0% |
| 4 | 35 | 5.0% |
| 5 | 35 | 5.0% |
| 6 | 70 | |
| 7 | 35 | 5.0% |
| 8 | 35 | 5.0% |
| 9 | 70 | |
| 10 | 140 |
| Value | Count | Frequency (%) |
| 12 | 105 | |
| 11 | 70 | |
| 10 | 140 | |
| 9 | 70 | |
| 8 | 35 | 5.0% |
| 7 | 35 | 5.0% |
| 6 | 70 | |
| 5 | 35 | 5.0% |
| 4 | 35 | 5.0% |
| 3 | 35 | 5.0% |
Month Name
Categorical
High correlation 
| Distinct | 12 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.6 KiB |
| October | |
|---|---|
| December | |
| June | |
| September | |
| November | |
| Other values (7) |
Length
| Max length | 9 |
|---|---|
| Median length | 8 |
| Mean length | 6.6 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | January |
|---|---|
| 2nd row | January |
| 3rd row | June |
| 4th row | June |
| 5th row | June |
Common Values
| Value | Count | Frequency (%) |
| October | 140 | |
| December | 105 | |
| June | 70 | |
| September | 70 | |
| November | 70 | |
| January | 35 | 5.0% |
| March | 35 | 5.0% |
| July | 35 | 5.0% |
| August | 35 | 5.0% |
| February | 35 | 5.0% |
| Other values (2) | 70 |
Length
| Value | Count | Frequency (%) |
| october | 140 | |
| december | 105 | |
| june | 70 | |
| september | 70 | |
| november | 70 | |
| january | 35 | 5.0% |
| march | 35 | 5.0% |
| july | 35 | 5.0% |
| august | 35 | 5.0% |
| february | 35 | 5.0% |
| Other values (2) | 70 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 910 | |
| r | 560 | |
| b | 420 | 9.1% |
| c | 280 | 6.1% |
| t | 245 | 5.3% |
| m | 245 | 5.3% |
| u | 245 | 5.3% |
| o | 210 | 4.5% |
| a | 175 | 3.8% |
| O | 140 | 3.0% |
| Other values (16) | 1190 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4620 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 910 | |
| r | 560 | |
| b | 420 | 9.1% |
| c | 280 | 6.1% |
| t | 245 | 5.3% |
| m | 245 | 5.3% |
| u | 245 | 5.3% |
| o | 210 | 4.5% |
| a | 175 | 3.8% |
| O | 140 | 3.0% |
| Other values (16) | 1190 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4620 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 910 | |
| r | 560 | |
| b | 420 | 9.1% |
| c | 280 | 6.1% |
| t | 245 | 5.3% |
| m | 245 | 5.3% |
| u | 245 | 5.3% |
| o | 210 | 4.5% |
| a | 175 | 3.8% |
| O | 140 | 3.0% |
| Other values (16) | 1190 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4620 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 910 | |
| r | 560 | |
| b | 420 | 9.1% |
| c | 280 | 6.1% |
| t | 245 | 5.3% |
| m | 245 | 5.3% |
| u | 245 | 5.3% |
| o | 210 | 4.5% |
| a | 175 | 3.8% |
| O | 140 | 3.0% |
| Other values (16) | 1190 |
Year
Categorical
High correlation 
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.6 KiB |
| 2014 | |
|---|---|
| 2013 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2014 |
|---|---|
| 2nd row | 2014 |
| 3rd row | 2014 |
| 4th row | 2014 |
| 5th row | 2014 |
Common Values
| Value | Count | Frequency (%) |
| 2014 | 525 | |
| 2013 | 175 | 25.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2014 | 525 | |
| 2013 | 175 | 25.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 700 | |
| 0 | 700 | |
| 1 | 700 | |
| 4 | 525 | |
| 3 | 175 | 6.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2800 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 700 | |
| 0 | 700 | |
| 1 | 700 | |
| 4 | 525 | |
| 3 | 175 | 6.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2800 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 700 | |
| 0 | 700 | |
| 1 | 700 | |
| 4 | 525 | |
| 3 | 175 | 6.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2800 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 700 | |
| 0 | 700 | |
| 1 | 700 | |
| 4 | 525 | |
| 3 | 175 | 6.2% |
Interactions
Correlations
| Sales | COGS | Country | Discount Band | Discounts | Gross Sales | Manufacturing Price | Month Name | Month Number | Product | Profit | Sale Price | Segment | Units Sold | Year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Sales | 1.000 | 0.971 | 0.066 | 0.123 | 0.773 | 0.999 | 0.030 | 0.068 | -0.034 | 0.000 | 0.581 | 0.869 | 0.365 | 0.376 | 0.155 |
| COGS | 0.971 | 1.000 | 0.062 | 0.110 | 0.777 | 0.973 | 0.032 | 0.075 | -0.023 | 0.000 | 0.474 | 0.852 | 0.390 | 0.365 | 0.111 |
| Country | 0.066 | 0.062 | 1.000 | 0.000 | 0.000 | 0.035 | 0.000 | 0.000 | 0.000 | 0.000 | 0.069 | 0.000 | 0.000 | 0.100 | 0.000 |
| Discount Band | 0.123 | 0.110 | 0.000 | 1.000 | 0.170 | 0.119 | 0.033 | 0.090 | 0.081 | 0.000 | 0.216 | 0.083 | 0.093 | 0.134 | 0.000 |
| Discounts | 0.773 | 0.777 | 0.000 | 0.170 | 1.000 | 0.791 | 0.057 | 0.086 | 0.008 | 0.000 | 0.350 | 0.707 | 0.256 | 0.272 | 0.088 |
| Gross Sales | 0.999 | 0.973 | 0.035 | 0.119 | 0.791 | 1.000 | 0.032 | 0.067 | -0.030 | 0.000 | 0.576 | 0.870 | 0.377 | 0.377 | 0.087 |
| Manufacturing Price | 0.030 | 0.032 | 0.000 | 0.033 | 0.057 | 0.032 | 1.000 | 0.000 | 0.004 | 0.998 | 0.036 | 0.056 | 0.000 | -0.023 | 0.000 |
| Month Name | 0.068 | 0.075 | 0.000 | 0.090 | 0.086 | 0.067 | 0.000 | 1.000 | 0.999 | 0.000 | 0.000 | 0.000 | 0.000 | 0.150 | 0.523 |
| Month Number | -0.034 | -0.023 | 0.000 | 0.081 | 0.008 | -0.030 | 0.004 | 0.999 | 1.000 | 0.000 | -0.044 | 0.000 | 0.000 | -0.066 | 0.517 |
| Product | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.998 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| Profit | 0.581 | 0.474 | 0.069 | 0.216 | 0.350 | 0.576 | 0.036 | 0.000 | -0.044 | 0.000 | 1.000 | 0.525 | 0.374 | 0.295 | 0.000 |
| Sale Price | 0.869 | 0.852 | 0.000 | 0.083 | 0.707 | 0.870 | 0.056 | 0.000 | 0.000 | 0.000 | 0.525 | 1.000 | 0.848 | -0.059 | 0.000 |
| Segment | 0.365 | 0.390 | 0.000 | 0.093 | 0.256 | 0.377 | 0.000 | 0.000 | 0.000 | 0.000 | 0.374 | 0.848 | 1.000 | 0.085 | 0.000 |
| Units Sold | 0.376 | 0.365 | 0.100 | 0.134 | 0.272 | 0.377 | -0.023 | 0.150 | -0.066 | 0.000 | 0.295 | -0.059 | 0.085 | 1.000 | 0.095 |
| Year | 0.155 | 0.111 | 0.000 | 0.000 | 0.088 | 0.087 | 0.000 | 0.523 | 0.517 | 0.000 | 0.000 | 0.000 | 0.000 | 0.095 | 1.000 |
Missing values
Sample
| Segment | Country | Product | Discount Band | Units Sold | Manufacturing Price | Sale Price | Gross Sales | Discounts | Sales | COGS | Profit | Date | Month Number | Month Name | Year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Government | Canada | Carretera | NaN | 1618.5 | 3 | 20 | 32370.0 | 0.0 | 32370.0 | 16185.0 | 16185.0 | 2014-01-01 | 1 | January | 2014 |
| 1 | Government | Germany | Carretera | NaN | 1321.0 | 3 | 20 | 26420.0 | 0.0 | 26420.0 | 13210.0 | 13210.0 | 2014-01-01 | 1 | January | 2014 |
| 2 | Midmarket | France | Carretera | NaN | 2178.0 | 3 | 15 | 32670.0 | 0.0 | 32670.0 | 21780.0 | 10890.0 | 2014-06-01 | 6 | June | 2014 |
| 3 | Midmarket | Germany | Carretera | NaN | 888.0 | 3 | 15 | 13320.0 | 0.0 | 13320.0 | 8880.0 | 4440.0 | 2014-06-01 | 6 | June | 2014 |
| 4 | Midmarket | Mexico | Carretera | NaN | 2470.0 | 3 | 15 | 37050.0 | 0.0 | 37050.0 | 24700.0 | 12350.0 | 2014-06-01 | 6 | June | 2014 |
| 5 | Government | Germany | Carretera | NaN | 1513.0 | 3 | 350 | 529550.0 | 0.0 | 529550.0 | 393380.0 | 136170.0 | 2014-12-01 | 12 | December | 2014 |
| 6 | Midmarket | Germany | Montana | NaN | 921.0 | 5 | 15 | 13815.0 | 0.0 | 13815.0 | 9210.0 | 4605.0 | 2014-03-01 | 3 | March | 2014 |
| 7 | Channel Partners | Canada | Montana | NaN | 2518.0 | 5 | 12 | 30216.0 | 0.0 | 30216.0 | 7554.0 | 22662.0 | 2014-06-01 | 6 | June | 2014 |
| 8 | Government | France | Montana | NaN | 1899.0 | 5 | 20 | 37980.0 | 0.0 | 37980.0 | 18990.0 | 18990.0 | 2014-06-01 | 6 | June | 2014 |
| 9 | Channel Partners | Germany | Montana | NaN | 1545.0 | 5 | 12 | 18540.0 | 0.0 | 18540.0 | 4635.0 | 13905.0 | 2014-06-01 | 6 | June | 2014 |
| Segment | Country | Product | Discount Band | Units Sold | Manufacturing Price | Sale Price | Gross Sales | Discounts | Sales | COGS | Profit | Date | Month Number | Month Name | Year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 690 | Government | United States of America | VTT | High | 267.0 | 250 | 20 | 5340.0 | 801.00 | 4539.00 | 2670.0 | 1869.00 | 2013-10-01 | 10 | October | 2013 |
| 691 | Midmarket | Germany | VTT | High | 1175.0 | 250 | 15 | 17625.0 | 2643.75 | 14981.25 | 11750.0 | 3231.25 | 2014-10-01 | 10 | October | 2014 |
| 692 | Enterprise | Canada | VTT | High | 2954.0 | 250 | 125 | 369250.0 | 55387.50 | 313862.50 | 354480.0 | -40617.50 | 2013-11-01 | 11 | November | 2013 |
| 693 | Enterprise | Germany | VTT | High | 552.0 | 250 | 125 | 69000.0 | 10350.00 | 58650.00 | 66240.0 | -7590.00 | 2014-11-01 | 11 | November | 2014 |
| 694 | Government | France | VTT | High | 293.0 | 250 | 20 | 5860.0 | 879.00 | 4981.00 | 2930.0 | 2051.00 | 2014-12-01 | 12 | December | 2014 |
| 695 | Small Business | France | Amarilla | High | 2475.0 | 260 | 300 | 742500.0 | 111375.00 | 631125.00 | 618750.0 | 12375.00 | 2014-03-01 | 3 | March | 2014 |
| 696 | Small Business | Mexico | Amarilla | High | 546.0 | 260 | 300 | 163800.0 | 24570.00 | 139230.00 | 136500.0 | 2730.00 | 2014-10-01 | 10 | October | 2014 |
| 697 | Government | Mexico | Montana | High | 1368.0 | 5 | 7 | 9576.0 | 1436.40 | 8139.60 | 6840.0 | 1299.60 | 2014-02-01 | 2 | February | 2014 |
| 698 | Government | Canada | Paseo | High | 723.0 | 10 | 7 | 5061.0 | 759.15 | 4301.85 | 3615.0 | 686.85 | 2014-04-01 | 4 | April | 2014 |
| 699 | Channel Partners | United States of America | VTT | High | 1806.0 | 250 | 12 | 21672.0 | 3250.80 | 18421.20 | 5418.0 | 13003.20 | 2014-05-01 | 5 | May | 2014 |